September 2018
This file contains information to introduce you to the TDM Excel Add-In. This file also provides you with help resources you can use while working with the TDM Excel Add-In.
The TDM Excel Add-In is a part of the NI TDM effort. This tool enables you to load TDM or TDMS files into Microsoft Excel. The TDM Excel Add-In is available for free download from ni.com. This tool is also integrated in the following NI products:
| Version | New features and changes |
|---|---|
| 2018 SP1 | Bug fixes. |
| 2018 | Support for generating all time channels when logging data of different measurement types at different rates. New model property returns the value TDM_1_0 which indicates the TDM file format. |
| 2017 | Maintenance release. |
| 2015 | Maintenance release. |
| 2014 | Support Microsoft Excel 2013 and some bug fixes. |
| 2012 | Bug fixes. |
| 2011 | Support Microsoft Excel 2010 (64-bit) and some bug fixes. |
| 2010 | Support Microsoft Excel 2010 (32-bit) and some bug fixes. |
| 3.1 | Bug fixes. |
| 3.0 | Support COM Automation and some bug fixes. |
| 2.1 | Support the TDMS 2.0 file format and some bug fixes. |
The TDM Excel Add-In has the following requirements:
The TDM Excel Add-In supports the following operating systems:
Note In 2016 the NI TDM Excel Add-In dropped support for Windows Vista, Windows XP, Windows Server 2003, and installations of Windows 7 without any service packs. The TDM Excel Add-In will not install or run on an unsupported OS. Additionally, after installing TDM Excel Add-In, you cannot use any installers built on this computer with any version of LabVIEW, LabWindows™/CVI™, NI TestStand™, or Measurement Studio on an unsupported OS.
For more information about the changes to our OS support for 2016, refer to KB 79UC78LS, Why Does my LabVIEW, LabWindows/CVI, Measurement Studio, or TestStand Built Installer Fail on Windows XP/Vista and Server 2003?.
Note Support for Windows 32-bit operating systems may require disabling physical address extension (PAE). To learn how this might affect your system and what actions you might need to take, visit ni.com/info and enter the Info Code PAESupport.
1 NI software installs VC2015 Runtime and .NET 4.6.2. Windows 8.1 and Windows Server 2012 R2 require Microsoft updates to support these items. Refer to Microsoft KB2919442 and KB2919355 for more information about how to install these updates.
2 NI software is signed with a SHA-256 certificate. Windows 7 SP1, Windows Embedded Standard 7 SP1, and Windows Server 2008 R2 SP1 require Microsoft updates to support SHA-256. Refer to Microsoft KB3033929 for more information about how to install this security update.
Double-click the setup.exe file and follow the instructions on the installation window to install the TDM Excel Add-In.
Refer to the TDM Excel Add-In Tool for Microsoft Excel User Guide at ni.com/zone for more information about using the TDM Excel Add-In.
The following items are the issues fixed in the TDM Excel Add-In and the version the issues were fixed.
| Fixed version | Fixed issue |
|---|---|
| 2018 SP1 | After installing LabVIEW 2018, Excel crashes when opening TDMS files. This issue was tracked by CAR 700825. |
| 2014 | COM Automation: Can't pass By Ref BSTR to ImportFile. |
| 2012 | Cell format of text channel value is not set to 'text'. |
| 2011 | Read decimation groups from TDMS files generated in Signal Express. |
| 2010 | Can't read more than 65536 rows data in Excel 2010. |
| 2010 | Can't load TDM Excel Add-In for the first time when Vista UAC is turned on. |
| 3.1 | Date/Time type mismatched to DT_DOUBLE and the value is displayed as number instead of date format. |
| 3.1 | TDM Importer buttons disappear in Excel 2007. |
| 3.1 | TDM Excel Add-In buttons have no response after clicked. |
| 3.0 | Error occurred in Vista when loading tdms file from network. |
| 2.1 | Add-In does not load more than 256 Channels in Excel 2007. |
| 2.0 | Installing TDM Excel AddIn part causes SignalExpress functionality to no longer work. |
Copyright
© 2009–2018 National Instruments. All rights reserved.
Under the copyright laws, this publication may not be reproduced or transmitted in any form, electronic or mechanical, including photocopying, recording, storing in an information retrieval system, or translating, in whole or in part, without the prior written consent of National Instruments Corporation.
NI respects the intellectual property of others, and we ask our users to do the same. NI software is protected by copyright and other intellectual property laws. Where NI software may be used to reproduce software or other materials belonging to others, you may use NI software only to reproduce materials that you may reproduce in accordance with the terms of any applicable license or other legal restriction.
End-User License Agreements and Third-Party Legal Notices
You can find end-user license agreements (EULAs) and third-party legal notices in the following locations after installation:
U.S. Government Restricted Rights
If you are an agency, department, or other entity of the United States Government ("Government"), the use, duplication, reproduction, release, modification, disclosure or transfer of the technical data included in this manual is governed by the Restricted Rights provisions under Federal Acquisition Regulation 52.227-14 for civilian agencies and Defense Federal Acquisition Regulation Supplement Section 252.227-7014 and 252.227-7015 for military agencies.
IVI Foundation Copyright Notice
Content from the IVI specifications reproduced with permission from the IVI Foundation.
The IVI Foundation and its member companies make no warranty of any kind with regard to this material, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. The IVI Foundation and its member companies shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance, or use of this material.
Trademarks
Refer to the NI Trademarks and Logo Guidelines at ni.com/trademarks for information on NI trademarks. Other product and company names mentioned herein are trademarks or trade names of their respective companies.
Patents
For patents covering the NI products/technology, refer to the appropriate location: Help»Patents in your software, the patents.txt file on your media, or the NI Patent Notice at ni.com/patents.